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)
The Future of Technology: Emerging Trends to Watch in 2025
Introduction As we navigate through 2025, the technological landscape continues to evolve at an unprecedented pace. Innovations that once se...
-
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