FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


SQL query help!!





kawkazEE
i have 3 tables all of them have a common field the date field. how do select all the data on all the table that has the date equal to 16/1/2007. please help!.. Crying or Very sad Crying or Very sad
jabapyth
Code:
SELECT * FROM table1, table2, table3
  WHERE date = 16/1/2007;
kawkazEE
ok ill try it... tnx!!!! Razz Razz
AOP Web Development
hello dude to be specific with your query try to use this


sql="select table1.date,table2.date,table3.date from table1,table2,table3 where table1.date = '1/19/2007' and table2.date='1/19/2007' and table3.date = '1/19/2007'";

that's all but if they have a relationship much better all you need is to relate them with 1 another... Laughing
Related topics
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.