Union left Join right join

[CrashBeta]

Could someone please post some Code SQL Code in Asp or PHP on Left Join right Join and unions for an access database
thank u

 

[PHV]

What have you tried so far and where are you stuck ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CrashBeta]

first i have the Access DB iData.mdb at ftp://sucontrol.com
i'm trying to create a proposals database,
it's a big undertaking and any help u can give me will be Awsome, if u look at that database i have a table called proposals [propsosals table {Engnumber} (Custname} Project name etc etc
Each Project has tasks (location 1 for project Southern Sioux,, under the Table tasks by the task description Location 1 in this case i have the items from our database that Goes to Location 1 now when i display this or add this in ASp or PHP what SQL am i going to have to use to acomplish this >??

 

[lespaul]

Understanding SQL Joins

UNION combines two like datasets:

SELECT Field1, Field2 FROM Table1
UNION
SELECT Field3, Field4 FROM Table2

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design