Hi Friends One task I have is to convert a MSSQL query to MYSQL query. One of the queries, I have to change is as follows: Select z.*, y.*, a.street1 , a.street2 , a.city , a.state , a.zip, a.clientlogo from NEW_MSDS_1 z, NEW_MSDS_2 y, Author_Client_Address a Where z.MSDS_ID = #URL.EDIT_MSDS_ID# and z.msds_id *= y.msds_id and z.Sec1Manufacturer_Address_ID *= a.Author_Client_Address_ID and z.Sec1Distributor_Address_ID *= b.Author_Client_Address_ID and z.Author_Client_Logo_id *= L.Author_Client_Logo_id In this case I am told that z.msds_id * has to be changes as it works only in MSSQL. How am I to change? What is the function of asterisk here? I could see no code in the website having this type of MSSQL query. When I convert it into a MYSQL query, will it work if the asterisk is removed? Thanks in advance for any help, Mahadevan Venkitaraman
the only problem is there is 2 table missing.... b. and L. --> the keys b.Author_Client_Address_ID and L.Author_Client_Logo_id dont exists