PHP Classes

REQUEST

Recommend this page to a friend!

      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   Report abuse  
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.