inner join

[Teuzzo]

SELECT *
FROM user INNER JOIN online
ON user.isp=online.isp
WHERE online.cd=1

Per la seconda:

...
WHERE user.gig=1