How to use "Inner join" without recordset disappearing??
I use the WADA wizard to build a backend ,
and I have to use inner join to make the data more meaningful ,
but , when I try to change the code in results.php
SELECT
PrimaryID, pCompanyID, ShortName, Name, pLandInOut_ID, pNowEnd
FROM
primary_insuarance_table ORDER BY pCompanyID ASC
into
SELECT
PrimaryID
, primary_insuarance_table.pCompanyID
, company.CompanyName
, primary_insuarance_table.ShortName
, primary_insuarance_table.Name
, primary_insuarance_table.pLandInOut_ID
, land_in_out.LandName
, primary_insuarance_table.pNowEnd
, now_end.NowEndName
FROM
backend.primary_insuarance_table
INNER JOIN backend.now_end
ON (primary_insuarance_table.pNowEnd = now_end.NowEndID)
INNER JOIN backend.land_in_out
ON (primary_insuarance_table.pLandInOut_ID = land_in_out.LandinOutID)
INNER JOIN backend.company
ON (primary_insuarance_table.pCompanyID = company.CompanyID)
the recordset in serverbehavior panel disappeared....
and the DAsearch got a "!" next to it ...
i think it must because the recordset is disappeared.....
So , please help me to solve this ...
and i have to do the same change in details.php and delete.php ...
and I will put the original files ....
if more information is needed ...
please tell me....