Multipart queries?

Multipart queries?

El Forum
Unregistered

02-10-2010, 06:44 AM

[eluser]JanDoToDo[/eluser]
SELECT * FROM (friendships LEFT JOIN user_profiles on friendships.member2 = user_profiles.user_id)
LEFT JOIN posts ON friendships.member2 = posts.user_id
WHERE friendships.member1 = '1' AND friendships.level = 'f' OR (friendships.level = 'a' AND posts.viewable = 'a')
ORDER BY posts.date DESC

This work?

Messages In This Thread

Multipart queries? - by El Forum - 02-09-2010, 05:08 PM

Multipart queries? - by El Forum - 02-09-2010, 06:33 PM

Multipart queries? - by El Forum - 02-09-2010, 06:35 PM

Multipart queries? - by El Forum - 02-09-2010, 07:04 PM

Multipart queries? - by El Forum - 02-10-2010, 02:59 AM

Multipart queries? - by El Forum - 02-10-2010, 04:04 AM

Multipart queries? - by El Forum - 02-10-2010, 04:37 AM

Multipart queries? - by El Forum - 02-10-2010, 05:37 AM

Multipart queries? - by El Forum - 02-10-2010, 06:44 AM

Multipart queries? - by El Forum - 02-10-2010, 06:57 AM

Multipart queries? - by El Forum - 02-10-2010, 08:31 AM

Multipart queries? - by El Forum - 02-10-2010, 08:44 AM

Multipart queries? - by El Forum - 02-10-2010, 08:51 AM

Multipart queries? - by El Forum - 02-10-2010, 11:56 AM

Multipart queries? - by El Forum - 02-10-2010, 02:23 PM