Login   Register  
PHP Classes
elePHPant
Icontem

REQUEST

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      Top level forums  >  PHP Specialists  >  General  >  REQUEST  
Subject:REQUEST
Summary:I wan to join 4 tables with calculation
Messages:3
Author:andrej hupka
Date:2009-01-31 05:41:48
Update:2009-02-10 18:06:39
 

  1. REQUEST   Reply  
Picture of andrej hupka
andrej hupka
2009-01-31 05:45:44
Hello

I have 4 tables.
1. Parts
this table content four fields
PartID (primary)
Reference (varchar)
Title (varchar)
PROJECTID (int)
2.Project
this table content two fields
PROJECTID (primary)
Title (varchar)
3. Entry
this table content two fields
PartID(int)
StockIn (int)
3. Sortie
this table content two fields
PartID(int)
StockOut (int)
Now I need join this tables like Table project with Table parts where Project.PROJECTID = parts.PROJECTID and Tables Parts,Entry and Sortie where Entry.PartId and Sortie.PartID=Parts.PartID
and StockIn and StockOut must be total
-------------------------------------------------------------------------
I try to do it and itīs OK, but like I use repeat region calculation does not work correctly.

Thanks for your help

There are 2 replies in this thread, which are not being displayed.
Browsing this forum thread replies is available only to premium subscribers.


Go to the premium subscriptions page to learn how to become a premium subscriber and have full access to this forum.