Create SQL JOIN statement to take fields from multiple tables such as Certfificate_table and CA_table

crtsh / certwatch_db

Database schema

https://crt.sh/

GNU General Public License v3.0

194 stars 36 forks source link

Create SQL JOIN statement to take fields from multiple tables such as Certfificate_table and CA_table #50

Closed bedford1234 closed 4 years ago

bedford1234 commented 6 years ago

Hello,

I would like to create a SQL JOIN statement to take fields from multiple tables such as Certfificate_table and CA_table in the PostgreSQL.. What is the best way to do this? I would greatly appreciate your help!

RufusJWB commented 5 years ago

Have a look here: https://github.com/crtsh/certwatch_db/issues/45 Maybe it helps