Re: Is this syntax is correct?

Amit Tandon wrote:

SELECT d.username, r.password FROM data join registration r on r.username

SELECT username FROM data, password FROM registration WHERE username=%s AND password=%s"

Oh, boy -- "r on r"?? Obviously the guy is a rookie. Let's be simple: SELECT data.username,registration.password FROM data inner join registration ON data.<linking_field> = registration.<linking_field> WHERE username=%s AND password=%s" <linking_field> is the name of the common field in each table, such as "user_id". Comments: 1. "data" is a really bad name for a table. You will confuse the heck out of yourself and others who follow you. Change it. 2. As Amit kind of said, no password should be stored in a table (available on a web server) without encrypting the password information. Ken