Can anyone give Query for this..

 hi

i want the query to join the three tables

1) FrontImage
styleid
colorid
fimage
fimagetype
fimagelength
fimagename
fimagetitle

2) BackImage
styleid
colorid
bimage
bimagetype
bimagelength
bimagename
bimagetitle

3) LogoImage
styleid
colorid
Limage
Limagetype
Limagelength
Limagename
Limagetitle

so i want to join these three table ie: on where condition style and colorid will match

ie: i want to retrieve the image from the above three tables where styleid and coloid will be same or (matches)

????
...