Just nu i M3-nätverket
Jump to content

Kontrollera om post finns i flera tabeller


Garanti Fri

Recommended Posts

SET RS=MyDBA.Execute("SELECT Username FROM TempUserDB , UserDB WHERE Username='"&Request.Form "Username")&"'")

 

IF NOT RS.EOF THEN

UsernameBusy = "True"

 

Vad jag vill kolla är om Username redan finns i

min temptabell och min riktiga tabell hur skulle

en SQL sats se ut för detta?

Link to comment
Share on other sites

SET RS=MyDBA.Execute("SELECT Username FROM TempUserDB, UserDB WHERE TempUserDB.Username=UserDB.Username AND UserDB.Username='" & Request.Form("Username") & "';")

 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.



×
×
  • Create New...