MySQL select Query to inner joint two tables on single field.
SELECT CASE
WHEN STATUS_FLAG=1 THEN (select id from table2 where
id=TABLE1.F_ID)
ELSE (select id from table3 where id=TABLE1.F_ID)
END
FROM TABLE1
Subscribe to:
Post Comments (Atom)
1980s Photo Prompts: Easy Online Copy & Paste
Are you on a quest to enhance your photography projects with a touch of nostalgic flair? Look no further than 1980s photo prompts. These car...
-
Put this code between <head>...</head> tag. <script type="text/javascript"> function readURL(input) { ...
-
Yes, normally datatable Ajax file call outside of AngularJs folder structure, If you define ng-click there then it’s not working in An... -
Using PHP to upload files into MySQL database sometimes needed by some web application. For instance for storing pdf documents or images to ...
Good Job. Helpful for beginner and intermediate.
ReplyDeleteThank you sir :)
Delete