SQL query getting error

Asked Mar 01 '17 at 07:55

Active Mar 30 '17 at 05:49

Viewed 36 times

I have a select query :

Select UID from att_value where Attributevalue="abc";

The output of this query is to be used to insert it into using the query :

Insert into useratt (ID,UID) Values ("123", output from the first query).

Can you please help me how to write a single query for this case.

edited Mar 30 '17 at 05:49

asked Mar 01 '17 at 07:55

Well did you try with other numbers before asking? – Jon Skeet Mar 01 '17 at 07:56
No, it's just `Integer`'s cache is only required to keep values from -128 to 127. – T.J. Crowder Mar 01 '17 at 07:57
Related answer: http://stackoverflow.com/a/2001861/157247 – T.J. Crowder Mar 01 '17 at 07:59
Another duplicate: http://stackoverflow.com/questions/1700081/why-does-128-128-return-false-but-127-127-return-true-when-converting-to-integ – T.J. Crowder Mar 01 '17 at 08:00

0 Answers0