[dustin56]

Originally Posted by ordique

MySQL error: Column 'NCR_No' in where clause is ambiguous

I believe this indicates that the field 'NCR_No' exists in more than one of the specified tables. You need to specify which table must be used in matching the where clause, or if this field must match in all tables which contain it, you have to specify that.
Like this

Code:

WHERE p.NCR_No='$ncrno'

or this

Code:

WHERE p.NCR_No='$ncrno' AND pl.NCR_No='$ncrno'