List Info

Thread: COMPLEX JOIN QUERY




COMPLEX JOIN QUERY
user name
2006-08-16 20:14:59
I am trying to figure out how to create a SQL query to find
all files
that are not joined to a folder. The current tables are like
this.

folders

files_folders - (file_id and folder_id)

files

I am trying to find all files that are not joined to any
folder that
belongs to user_id , the files however could be jouined to a
folder of
a different user_id ...


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )