w32crazydev Level: Guest

|
Re: query help
you need to build an sql string
like this
dim strdata
strdata="SELECT A,B,C,D FROM A,B,C,D"
this means that you refer to all the fields that you want to reach in the database tables and then refer to the tables that contain it.
for example:
select name,surname,salary from pdata,jobs
SQL will automatically find from where on pdata,jobs to search for name,salary,surname
(surname and name could be found on pdata or jobs)
but this method does not work in tables who have the same fields.
if you want to search tables with same fields contact me on leadcpp@yahoo.com to tell you how....
ellinas eisai re? kai go ellinas eimai...
|