If you used join query on parent table and child table and you want to fetch unique records from both table then see the below example
SELECT COUNT(DISTINCT(t1.id)) FROM table1 t1 left join table2 t2 on t2.id=t1.t2id
Enjoy!
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 ...
ReplyDeleteI have read your blog its very attractive and impressive. I like it your blog.
PHP 7 Training in chennai | PHP 7 Training Course
PHP 7 Training in chennai | Online PHP 7 Course