[RESOLVED] join 3 tables confusion...

[v3nt]

hello!

going round in circles with a join tables query!

tables;

noticeAssoc
fields: contentID, userIDB
// joins to
content
// using contentID
users
// using userIDB

what would be the best way to join these. There will be a corresponding entry in all 3 table per entry.

any hints welcome!

[laserlight]

I think that you should present more information on what exactly it is that you are trying to select.

[v3nt]

trying to select all the fields from the 3 tables.

just got it working;

		$sql = "SELECT * FROM noticeAssoc 
				LEFT JOIN users ON noticeAssoc.userIDB=users.userIDB 
				LEFT JOIN content ON noticeAssoc.contentID=content.contentID $q";