parent table called lp_files
id
filename
filedescription
filetype
etc
child table called lp_contexts
id
fileid
context
I need to do a join to join those two tables together selecting all the info from the parent table based on information in the context field of the child table.
right now I have it working with a subquery but I need to use a different join type to speed up my query some.
here's what I have right now:
Code: Select all
select * from lp_files where id in (select fileid from lp_contexts where context in ('one','two','three))