question

cyberrule avatar image
cyberrule asked

select id and concatenate with another query

I have two table. 1. User_login 2. User_detail user_login table has: 1. user_id 2. username 3. password user_detail table has: 1. key 2. value I have made mistake when I stored data. I stored name with user_id example: firstname_1 --> Dani firstname_2 --> Alex Now I would like to get firstnames how can I concatenate 'firstname' with get value of userid?
sqljoin
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sjimmo avatar image sjimmo commented ·
Can you post a copy of the data as it appears in the tables? Can you also show us what you have tried?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.