Problem with Query
-
select distinct(ps.pax_id),ps.barcode_no,ps.modified_date,ps.passport_no,pd.pax_fname+' '+pd.pax_mname+' '+pd.pax_lname as pax_name,ps.fromBranch,ps.passport_status,ps.toBranch,ps.consulate,pv.travel_date,pv.tour_code,ps.entered_date,ps.branch_id,ps.status_type,bm.branch_name from passport_status_tran ps,pass_branch_mst bm,passport_details pd,pax_visarequirments pv where bm.branch_id=pd.branch_id and bm.branch_id='9' and ps.fromBranch='5' and ps.barcode_no=pd.barcode_no and pd.pax_id=pv.pax_id and ps.passport_status='out' and ps.entered_date between '03/24/2007' and '03/27/2007' order by ps.entered_date This query is running but giving double entry. Passport No Consulate XYZ Belgium XYZ Belgium
-
select distinct(ps.pax_id),ps.barcode_no,ps.modified_date,ps.passport_no,pd.pax_fname+' '+pd.pax_mname+' '+pd.pax_lname as pax_name,ps.fromBranch,ps.passport_status,ps.toBranch,ps.consulate,pv.travel_date,pv.tour_code,ps.entered_date,ps.branch_id,ps.status_type,bm.branch_name from passport_status_tran ps,pass_branch_mst bm,passport_details pd,pax_visarequirments pv where bm.branch_id=pd.branch_id and bm.branch_id='9' and ps.fromBranch='5' and ps.barcode_no=pd.barcode_no and pd.pax_id=pv.pax_id and ps.passport_status='out' and ps.entered_date between '03/24/2007' and '03/27/2007' order by ps.entered_date This query is running but giving double entry. Passport No Consulate XYZ Belgium XYZ Belgium
try following, SELECT distinct * from ( select distinct(ps.pax_id),ps.barcode_no,ps.modified_date,ps.passport_no,pd.pax_fname+' '+pd.pax_mname+' '+pd.pax_lname as pax_name,ps.fromBranch,ps.passport_status,ps.toBranch,ps.consulate,pv.travel_date,pv.tour_code,ps.entered_date,ps.branch_id,ps.status_type,bm.branch_name from passport_status_tran ps,pass_branch_mst bm,passport_details pd,pax_visarequirments pv where bm.branch_id=pd.branch_id and bm.branch_id='9' and ps.fromBranch='5' and ps.barcode_no=pd.barcode_no and pd.pax_id=pv.pax_id and ps.passport_status='out' and ps.entered_date between '03/24/2007' and '03/27/2007')ttemp order by ttemp.entered_date
Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.