From the link above I can see that these fields are not available, Is there any way to link a contact to the case? The information is available when browsing a contact or customer record.

This works for me

SELECT
  SC.contactid,
  C.email,
  C.firstname,
  C.lastname,
  C.company
FROM
  supportCase AS SC
  join contact C on C.id = SC.contactid

You will need to make sure you have the correct permissions too.

Hi @Jay Jetley Thank you for your response, unfortunately, I found out that the field is not exposed for searches.