Query Problem

[aman179]

What is wrong in this code

$query = "SELECT ledger.bill_no,ledger.ref_no,ledger.bill_date,ledger.insurers,ledger.issuing_office,ledger.insured_name,ledger.vehicle_no,ledger.vehicle,ledger.type_of_report,sfb.insured_address,sfb.prof_fees,sfb.prof_fees_desc,sfb.photos_nos,sfb.photos,sfb.conveyance_desc,sfb.conveyance,sfb.halting_desc,sfb.halting,sfb.misc_desc,sfb.misc,sfb.total,sfb.service_tax_rate,sfb.service_tax,sfb.survey_fees,sfb.in_words,sfb.remarks FROM ledger,sfb WHERE ledger.bill_no='$bill_no' AND sfb.bill_no='$bill_no'";

[guido2004]

Why? Do you get an error? A result you didn't expect?

[r937]

what's
wrong?
you
mean,
other
than
the
fact
that
the
query
is
all
strung
out
on
a
single
humoungously
long
line
which
makes
it
almost
impossible
for
a
human
being
to
read
and
understand?

[aman179]

what's
wrong?
you
mean,
other
than
the
fact
that
the
query
is
all
strung
out
on
a
single
humoungously
long
line
which
makes
it
almost
impossible
for
a
human
being
to
read
and
understand?

ohh...
I changed the query to

SELECT ledger.bill_no,ledger.ref_no,ledger.bill_date,ledger.insurers,ledger.issuing_office,
	      ledger.insured_name,ledger.vehicle_no,ledger.vehicle,ledger.type_of_report,sfb.insured_address,
		  sfb.prof_fees,sfb.prof_fees_desc,sfb.photos_nos,sfb.photos,sfb.conveyance_desc,sfb.conveyance,
		  sfb.halting_desc,sfb.halting,sfb.misc_desc,sfb.misc,sfb.total,sfb.service_tax_rate,sfb.service_tax,
		  sfb.survey_fees,sfb.in_words,sfb.remarks FROM ledger
		  INNER JOIN sfb ON ledger.bill_no=sfb.bill_no WHERE ledger.bill_no='$bill_no'";

There are 72 record are in ledger table & 2 record are in sfb table with bill_no in both tables. I am getting same insured_address & same prof_fees if I supply different bill no.

[r937]

it's gotta be a data problem, your join is fine

[aman179]

thanks Mr r937, yeah i got the solution. I was becoz of difference between # of rows in both tables. I sorted out the problem. Now in both tables I have same number of rows 73 record in boths tables & now the query is working fyn