mysql query

[prasadalone]

Following is my mssql query i want to convert this query into mssql query tell me how thank you

Select firstname +' '+lastname+' userid :'+Users.userid ,PrayerDetails,PrayerRequestDate,Paidstatus,PrayerRequest.PrayerRequestId,t1.tcnt from PrayerRequest,UserPrayerRequest,Users,(select count(*) as tcnt,PrayerRequestId from UsersReplys group by PrayerRequestId) as t1 where Users.UserId = UserPrayerRequest.Userid and UserPrayerRequest.userid <> 'aratidesai' and UserPrayerRequest.PrayerRequestId*= t1.PrayerRequestId and PrayerRequest.PrayerRequestId=UserPrayerRequest.PrayerRequestId and PrayerRequest.PrayerRequestId Not in (Select PrayerRequestId from UsersReplys where userid='aratidesai')

 

[TonyGroves]

If you were to make some effort to make your query readable, you might get a better response.

 

[r937]

you want to convert a microsoft SQL Server query to mysql, right?

before you do this, you must convert your query from "table list" syntax (i.e. FROM A,B,C...) to JOIN syntax (i.e. FROM A INNER JOIN B ON ...)

hint: you will need a LEFT OUTER JOIN for the relationship between UserPrayerRequest and t1

once you have finished the conversion to JOIN syntax, and tested it completely in SQL Server, then come back and show us the query

r937.com | rudy.ca