Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in MySQL only
Search
Advanced Search
Forums
BYTES
Product Launch
Updates
Developer Toolkit
Member List
Calendar
Today's Posts
Home
Forum
Topic
MySQL
Problem in Join two tables
Problem in Join two tables
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
younker1983
New Member
Join Date:
Dec 2007
Posts:
1
#1
Problem in Join two tables
Dec 27 '07, 07:43 AM
Hi, please help me to sortout this problem..... I have two tables (category and Members)
Tables are like this
Thanks
amitpatel66
Recognized Expert
Top Contributor
Join Date:
Mar 2007
Posts:
2358
#2
Dec 27 '07, 11:27 AM
Originally posted by
younker1983
Hi, please help me to sortout this problem..... I have two tables (category and Members)
Tables are like this
Thanks
Hi Younker1983,
Welcome to TSDN!!
Could you please post your table structure here rather than providing the link for our experts to visit?
All the experts here are professionals working in various big organizations and in most of the organizations the blog websites are blocked.
MODERATOR
Comment
Post
Cancel
Shalini Bhalla
New Member
Join Date:
Dec 2007
Posts:
190
#3
Dec 29 '07, 04:46 PM
hi ,
I have not seen table structure but if you can chage the stored data as
cat_id cat_name
1 sin-music dir-Lyric
2 singer-music dir
3 music-dir--sing
Like this you can solve your problem
Comment
Post
Cancel
mwasif
Recognized Expert
Contributor
Join Date:
Jul 2006
Posts:
802
#4
Dec 30 '07, 10:58 AM
Originally posted by
younker1983
Hi, please help me to sortout this problem..... I have two tables (category and Members)
What you have tried so far?
Comment
Post
Cancel
t3chn0n3rd
New Member
Join Date:
Dec 2007
Posts:
19
#5
Dec 30 '07, 03:26 PM
can you join on CAT_ID and MEMBER_ID
Comment
Post
Cancel
Shalini Bhalla
New Member
Join Date:
Dec 2007
Posts:
190
#6
Jan 7 '08, 04:30 AM
Sorry for replying late ....
Hapy new Year ...
Any ways , You can not because join feilds should cantain same type of data in it . that is why i told you that if you can chage your data in category table it would be more easier for you .....
regards
shalini
Comment
Post
Cancel
Previous
template
Next
Working...
OK
OK
Cancel
👍
👎
☕
Comment