Search results

Hi Bob, the database is Oracle & i am accessing the table thru access (ODBC).

hi bob, hope you have seen the query which i have posted on the forum. thanks

Hi Bob, Any update, hope you have got the query which i have posted. Pls see if you can help me here. the table from which im trying to extract the info is live database table. this query is working fine on the table copied on my system. but giving error when running on the live database table...

here is the sql query, SELECT SOPHIE_B_COMP_A.C_REFER, SOPHIE_B_COMP_A.MARQUE, SOPHIE_B_COMP_A.N_SERI, SOPHIE_B_COMP_A.C_PRIX_UNI, [INSTRU PL].[Item Number], [INSTRU PL].[TP Saudi USD], SOPHIE_B_COMP_A.C_STOCK_LI FROM SOPHIE_B_COMP_A INNER JOIN [INSTRU PL] ON SOPHIE_B_COMP_A.C_REFER = [INSTRU...

Hi, I am trying to filter the records of a table with a text from one column but its not filtering it. The column that i want to filter is for the text "SAUWH" but it bringing all the other records for the other text which is EGYWH & TURWH etc. I just wanted to filter the column for only SAUWH...