Recent content by hengsin

table: sales field: manufacturing code Data inside manufacturing code: IM2, IM, SIS, SIS2, PASSO2, APC2, SeeFei2, SeeFei I want use the SQL to display the data with 2 at the back only. I know there is a stupid to do that, i.e. ....where ManufacturingCode= "IM2" or...

It was just a though because i believed i should put something mechanism to check this one in my future ms access database design. Thanks

Something very interesting issue to think of. Personally, i believed that there will be limitation in Ms Access like Ms Excel on the database it can store. The maximum row that Ms Excel can go is until 65536. So, what if the database in Ms Access is reaching maximum i.e. cannot store additional...

actually i already tried it after i posted the message on here. It's working...

just wanna to know somethig about Oracle as i'm new to it. As i know, Oralce 7 doesn't support INNER JOIN and Oracle 9 can. My computer is installed with Oracle 7 client. The server is running Oracle 9 server. Can i use the INNER JOIN in my SQL*Plus, Oracle 7 using INNER JOIN command in my SQL...

tblPart = Part_Num,Business_Unit_Id tblOrderDetail = Part_num,Business_Unit_Id tblCorp = Business_Unit_Id I have three tables as stated above. I want to equi-join tblPart.Part_Num = tblOrderDetail.Part_Num and tblPart.Business_Unit_Id = tblOrderDetail.Business_UnitId and...

In the WHERE clause.... .... where area = "india" or area "china" can be equivalent to: where area IN("india","china"). What if: where area like "a*" or area like "b*" How to put the Like and IN command together?

hi, just want to make sure is it my conversion is correct regarding the MS Access SQL and "Native" SQL conversion regarding the join: Here is the SQl from MS Access FROM (ASIA.PROD_ORDER_DETAIL_ASIA INNER JOIN ASIA.PART_ASIA ON (ASIA.PROD_ORDER_DETAIL_ASIA.BUSINESS_UNIT_ID =...

or yah, it's "Equi join". As my first language is not English. I'm always thinking it's "Equal"

hi, just want to clarify something. Is it INNER JOIN is same as EQUAL-JOIN. If not, what is the different

thanks for the help in Pass Through Query. Now i'm able to help the company to increase the productivity. They used the table to link to ODBC datasource then only use the local machine to excute the query to filter whethever they want. THis process usually will take up to three hours. With Pass...

as i understand, if i want to build up a new table using query, i can put the INTO tblName somewhere in the query to build up a new table. Now i'm writing the Pass-through Query to obtained the data from Oracle database. So, i need to use the Oracle-syntax to write out the query. Next, i...

go to the control and right click. Select the Font property then you can change it.

now i'm understanding what is pass through query. Thanks for the inputs and other issues arise or maybe need to take care.

maybe the relevant person can turn this to become FAQ for the benefits for other people.........