tbl_homepageids has three columns, fld_article1, fld_article2 and fld_article3 each having a value manually inputted to indicate which article to select from tbl_press
tbl_press has many columns, but the key one in this instance is a field called 'fld_id' which is the value I am trying to get the home page to read via use of tbl_homepageids.
Basically, I am trying to use the table 'tbl_homepageids' as the engine to select the correct articles from the table 'tbl_press'.
The recordset/SQL statement I am trying to create goes like this:
SELECT * FROM tbl_homepageids, tbl_press WHERE fld_article1,tbl_homepageids LIKE fld_id,tbl_press
I will create another two recordsets/SQL statements for the other two press articles using fld_article2 and fld_article3.
Quite obviously the statement here isn't working and I have tried many different variations on the same theme, but haven't managed to achieve the results required, so I have written it in its simplest format hoping somebody can understand what I need and help me through this trying period in my life!!
TIA
Mat
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
