SQL Inner Join – How to Join 3 Tables in SQL and MySQL

When you’re working with your database, you might need to put together data from a few different tables. This article will show you how. I have already written about SQL joins here [/news/sql-join-types-inner-join-vs-outer-join-example/] and here [/news/sql-left-join-example-join-statement-syntax/], but let’s take a moment to review how a join works first, and particularly

“Can it run Doom” will never be the same, thanks to new ray-tracing mod

E2M1 has never looked so cool. Welcome to the ray-traced <em>Doom</em> experience.

Enlarge / E2M1 has never looked so cool. Welcome to the ray-traced Doom experience. (credit: id Software)

Since the launch of Quake II RTX in 2019, fans have kept their eyes peeled for similar ray- and path-tracing updates for other classic ’90s shooters. It’s fertile upgrade territory, since modern machines push vanilla versions of Doom and Quake to over 1,000 fps by default—that’s wiggle room for computationally expensive lighting techniques—but those games’s official handlers haven’t really moved the ray-tracing needle.

Instead, Friday’s good news comes from the Doom community: The first three episodes of Doom 1 (1993) can now be played with top-to-bottom ray tracing enabled. Yes, I know, I see the date at the top of this article, but I swear: I installed and tested Doom within the new PRBoom+RT engine, and the results have not only looked quite good but felt surprisingly performative.

That is helped in large part by native support within the new engine for both Nvidia DLSS and AMD FSR. While you wouldn’t need either to run vanilla Doom, both of these upscaling systems help in a ray tracing update because they also shrink the base resolution of so many realistically rendered light bounces. The upscaling toggle makes a big performance difference: On my default testing rig (RTX 3080 Ti, AMD Ryzen 7 5800X overclocked), the “DLSS quality” toggle at 2160p resolution increases ray-tracing performance nearly 100 percent compared to a raw 2160p signal, from 33 fps to 61 fps in E1M1. You can scrape even more frames by playing around with lower-resolution DLSS and FSR settings.

Read 6 remaining paragraphs | Comments

Biden sanctions Russian tech companies, including country’s biggest chipmaker

Treasury Secretary Janet Yellen.

Enlarge / Treasury Secretary Janet Yellen. (credit: Jason Connolly-Pool/Getty Images)

The Biden administration slapped a new round of sanctions on Russia, with a focus on technology companies that support the Russian war effort in Ukraine. Among the sanctioned companies is Mikron, Russia’s largest chipmaker.

“We will continue to target Putin’s war machine with sanctions from every angle until this senseless war of choice is over,” said Treasury Secretary Janet Yellen in the Treasury Department’s press release announcing the action.

Many of Mikron’s chips are used in bank cards, identification cards, and RFID tags. The company also manufactures power management chips. In addition to supplying technology for Russian military operations, the US says Mikron is responsible for a majority of Russia’s chip exports. So hobbling the company could help starve Russia of the hard currency it needs to pay for imports.

Read 7 remaining paragraphs | Comments

Game dev group says addressing NFT gaming’s “ethical issues” is a “priority”

While some see NFT games like <em>Axie Infinity</em> as the future of gaming, the IGDA is increasingly worried about the ethical issues inherent to the space.

Enlarge / While some see NFT games like Axie Infinity as the future of gaming, the IGDA is increasingly worried about the ethical issues inherent to the space.

The International Game Developers Association (IGDA), a professional group of thousands of game makers from around the world, is increasingly concerned that the “ethical issues” surrounding the use of non-fungible tokens in gaming represents a “socio-political explosion waiting to happen.” That’s according to Dr. Jakin Vela, the founder of social justice-focused gaming nonprofit Games for Me. Vela was recently named interim director of the IGDA.

In an interview with Ars, Vela expanded on the IGDA’s “call to action” statement on NFTs in gaming from last July. That statement was critical of the technology and focused on the “energy inefficient methods” inherent to the proof-of-work blockchains that dominate the cryptocurrency and NFT space. “NFTs should never be used [by game developers] when a simple and far less costly database table can be managed to provide the same information and benefits,” the group said.

The IGDA’s Climate Special Interest Group also compiled a growing list of arguments against NFTs in gaming. That document notes that gaming communities and game developers are largely uninterested in the technology, with 70 percent of game makers saying in a recent survey that they have no interest in using NFTs in their upcoming projects.

Read 7 remaining paragraphs | Comments

This adorable 1-inch HDMI monitor doesn’t need a power supply

A 0.96-inch PC monitor.

Enlarge / A 0.96-inch PC monitor. (credit: mitxela/YouTube)

When you think of a display that connects to its source over HDMI, you probably think of the TV in your living room, your desktop monitor, or maybe even a smaller display, like a portable monitor. You probably don’t think of an OLED PC monitor that measures 0.96 of an inch diagonally.

While acknowledging the limited uses for a tiny HDMI PC monitor, maker mitxela had the urge to get a 128×68 dot matrix OLED screen up and running as a PC monitor that connects directly to its system. The maker described the creation as the “smallest and worst HDMI display ever.”

A small OLED screen isn’t special on its own. Makers use them for all sorts of projects, like DIY smartwatches, message boards, or weather displays, for example. What makes mitxela’s project unique is that it turns the OLED panel into a standard PC monitor that can be plugged into the PC’s HDMI port directly—no Arduino or microcontroller required.

Read 7 remaining paragraphs | Comments

Three cylinders, all-wheel drive, and 300 hp: The Toyota GR Corolla

A grey Toyota GR Corolla

Enlarge / You’d be forgiven for thinking this is a WRX, but it’s actually the new Toyota GR Corolla. (credit: Toyota)

By and large, Toyota is known for dependable but boring cars. But among the millions of RAV4s and Camrys, there is evidence of a wilder streak. There’s the Supra, of course, which is flashy in a way that few cars are today. And there’s the GR Yaris, which was designed to homologate a rally car before a rule change rendered it obsolete.

“GR” stands for Gazoo Racing, and it seems that the GR magic transformed the Yaris into a cult favorite. Toyota didn’t sell this little three-cylinder, all-wheel-drive pocket rocket in the US market, but it will bring the follow-up, the GR Corolla, to the country. The GR Corolla is also powered by a turbocharged 1.6 L three-cylinder engine and features AWD, and it goes on sale later this year.

Like the GR Yaris, the GR Corolla is built at a special factory in Motomachi, Japan, as opposed to being made at the normal Corolla line at the company’s Takaoka plant. The car’s body has been strengthened with stronger welds and adhesives, and buyers get the option of a forged carbon-fiber roof to save weight where it really counts.

Read 5 remaining paragraphs | Comments

Find the soul