joining 3 table

[rbauerle]

could anyone show me an example of joining 3 tables??? I try to do it, but it won´t work.

Thanx

 

[ToddWW]

Sure. Here's an example.

Table: customer
Fields:
custid
custname
custcity

Table: site
Fields:
custid
siteid
sitename
sitecity

Table: user
Fields:
siteid
userid
firstname
lastname

SELECT customer.customername, site.sitename, user.firstname, user.lastname FROM customer, site, user WHERE user.siteid=site.siteid AND site.custid=customer.custid

ToddWW