Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bettyatolive
Starting Member
21 Posts |
 Posted - 2006-06-07 : 05:20:09
|
| Can you please tell me what the error in this Query is...SELECT sk.SK_Name, sh.SH_Received, so.SO_Sold, sk.SK_UnitPrice, so.SO_SalesAmount FROM Tbl_HO_Stock sk, Tbl_HO_StockHistory sh, Tbl_HO_StockOutwards so WHERE sk.SK_RCSKID_FK = so.SO_SKID_FK AND sk.SK_RCSKID_FK = sh.SH_SKID_FK date_format(sh.SH_Date,'%y-%m-%d')>='2006-06-01' and date_format(sh.SH_Date,'%y-%m-%d')<='2006-06-05' and sk.SK_RCID_FK=4it is showing an error msg as follows:MySQL said: #1064 - You have an error in your SQL syntax near '( so.SO_Date, '%y-%m-%d' ) >= '2006-06-01' AND Please help me to correct the query. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-07 : 05:31:03
|
| Are you using MySQL?This is SQL Server Forum. Post your MySQL questions at www.MySQL.comMadhivananFailing to plan is Planning to fail |
 |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2006-06-07 : 05:31:57
|
| This is a SQL Server forum - try http://forums.mysql.com/Ryan Randallwww.monsoonmalabar.com London-based IT consultancy Solutions are easy. Understanding the problem, now, that's the hard part. |
|
|
|
|
|
|
Query Help