Jump to content

Getting Record from Two tables


arifsor

Recommended Posts

Hello

i have two tables Clinic, Clicks

Clinic
====
CLINIC_ID
CLINIC_NAME

Clicks
====
CLINIC_ID
DATE_TIME

whenever visitor of the website click on the clinic name name my program insert clinic_id and date_time intto the Clicks table.




Issue:
=====
i want to display the report

Clinic Name Clicks
=======================
abc clinic 54
xyz clinic 45


[b]is this possible using only One query?[/b]


Link to comment
Share on other sites

I think this should do it:
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] a.*, b.* [color=green]FROM[/color] [color=orange]Clinc[/color] a, Clicks b [color=green]WHERE[/color] a.CLINIC_ID [color=orange]=[/color] b.CLINIC_ID [!--sql2--][/div][!--sql3--]
Link to comment
Share on other sites

[!--quoteo(post=365476:date=Apr 17 2006, 03:30 AM:name=wildteen88)--][div class=\'quotetop\']QUOTE(wildteen88 @ Apr 17 2006, 03:30 AM) [snapback]365476[/snapback][/div][div class=\'quotemain\'][!--quotec--]
I think this should do it:
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] a.*, b.* [color=green]FROM[/color] [color=orange]Clinc[/color] a, Clicks b [color=green]WHERE[/color] a.CLINIC_ID [color=orange]=[/color] b.CLINIC_ID [!--sql2--][/div][!--sql3--]
[/quote]

No this will not work.
let me clear
following is the schema of tables


CLINIC

CLINIC_ID CLINIC_NAME
==================================
10 Abc Clinic
11 Xyz Clinic

CLICKS

CLICK_ID CLINIC_ID DATE_TIME
====================================
1 10 04-17-2006
2 10 04-17-2006
3 10 04-17-2006
4 11 04-17-2006


I WANT OUT PUT LIKE

CLINIC_NAME CLICKS
=======================
Abc Clinic 3
Xyz Cinic 1

[b]using only one query[/b]
Link to comment
Share on other sites

Oh, sorry I missunderstood. My MySQL Query knowledge is little vague but I think something like thi should do it:
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] a.CLINIC_ID, a.CLINIC_NAME, [color=blue]COUNT[/color](b.CLINIC_ID), b.DATE_TIME [color=green]FROM[/color] [color=orange]`CLINIC`[/color] a, `Clicks` b [color=green]WHERE[/color] a.CLINIC_ID [color=orange]=[/color] b.CLINIC_ID GROUP BY a.CLINIC_NAME [!--sql2--][/div][!--sql3--]
Link to comment
Share on other sites

[!--quoteo(post=365484:date=Apr 17 2006, 04:39 AM:name=wildteen88)--][div class=\'quotetop\']QUOTE(wildteen88 @ Apr 17 2006, 04:39 AM) [snapback]365484[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Oh, sorry I missunderstood. My MySQL Query knowledge is little vague but I think something like thi should do it:
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] a.CLINIC_ID, a.CLINIC_NAME, [color=blue]COUNT[/color](b.CLINIC_ID), b.DATE_TIME [color=green]FROM[/color] [color=orange]`CLINIC`[/color] a, `Clicks` b [color=green]WHERE[/color] a.CLINIC_ID [color=orange]=[/color] b.CLINIC_ID GROUP BY a.CLINIC_NAME [!--sql2--][/div][!--sql3--]
[/quote]

it is workingm, but showing only those clinics whihc have some clicks, if there is no click on any clinic than it should display 0
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.